package com.example.test_17;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface articleInfoMapper {
    List<articleInfo> selectall();

    @Select("select ta.*, tb.username,tb.password,tb.phone,tb.gender from articleinfo ta left join user_info tb on ta.uid=tb.id")
    UserInfo select();
}
